﻿CREATE TABLE [dbo].[InvoiceDetail] (
    [InvoiceNo] VARCHAR (30)    NOT NULL,
    [LineNo]    VARCHAR (3)     NOT NULL,
    [ProductNo] VARCHAR (10)    NOT NULL,
    [Qty]       NUMERIC (10, 2) NULL,
    [Price]     NUMERIC (10, 2) NULL,
    [Amount]    NUMERIC (15, 2) NULL,
    [TaxRate]   NUMERIC (10, 4) NULL,
    [TaxAmount] NUMERIC (15, 2) NULL,
    [Remark]    VARCHAR (60)    NULL,
    [RecordID]  INT             IDENTITY (1, 1) NOT NULL
);

